Skip to main content

INVENTORYMASTER to INV.MST Synchronization and Reconciliation

May 22, 2023

  • Output from INV.MST
    • See DICT INV.MST @MD.UNLOAD.NEW Update INV.MST with PRODUCTID from SV1020 INVENTORYMASTER and Reconciliation:
  • From INVENTORYMASTER
    • See o:\misgrp\multidev\inventorymasterEXPORT.sql
    • Export results to a .TAB delimited file
    • Save as K:\MERCHGRP\INVENTORYMASTEREXPORT.TAB
  • To INV.MST
    • See IC246
    • IC246 will
      • Import the TAB file into a temp area.
      • Update INV.MST with PRODUCTID from unload script